Course 1561B - Module 4

Designing a Schema Policy

Overview

Designing a schema policy is a cornerstone of effective database management, ensuring that the data structure is both robust and adaptable. A thoughtfully crafted schema policy provides a framework that balances performance, scalability, and maintainability.

Identifying Business Needs


Schema Fundamentals
Image








Implications of Modifying the Schema


Planning for Schema Modification
Situation Suggested Solutions
No existing class meets needs Create a new class
Existing class needs attributes but otherwise meets needs Create new attributes, derive a new child class, or create an auxiliary class
Need a new set of unique attributes, but not a new class Create auxiliary class
Existing classes or attributes no longer needed Deactivate existing class or attribute
















No comments yet.

Leave a Comment